Table: Contract Pricing

Table: ICCUPR
View: IC0274
Record length: 130
Flags: A R 

Keys: 1

Title  Flags  Fields
Customer Number   CUSTNO, PRICEBY, CATEGORY, ITEMNO, PRICELIST

Fields: 19

Field  Type  Title  Presentation 
CUSTNO  String*12  Customer Number  Mask: %-12C
PRICEBY  Integer  Price By  List: 2 entries
1=Category Code
2=Item Number
CATEGORY  String*6  Category Code  Mask: %-6N
ITEMNO  String*24  Item Number  Mask: %-24C
PRICELIST  String*6  Price List  Mask: %-6N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
EXPIRE  Date  Expiration Date   
PRICETYPE  Integer  Price Type  List: 6 entries
1=Customer Type
2=Discount Percentage
3=Discount Amount
4=Cost Plus a Percentage
5=Cost Plus Fixed Amount
6=Fixed Price
CUSTTYPE  Integer  Customer Type  List: 6 entries
1=Base
2=A
3=B
4=C
5=D
6=E
DISCPER  BCD*5.5  Discount Percentage   
DISCAMT  BCD*10.6  Discount Amount   
COSTMETHOD  Integer  Costing Method  List: 7 entries
1=Markup Cost
2=Standard Cost
3=Most Recent Cost
4=Average Cost
5=Last Unit Cost
6=Landed
7=Alt.Amt.2
PLUSAMT  BCD*10.6  Plus Amount   
PLUSPER  BCD*5.5  Plus Percentage   
FIXPRICE  BCD*10.6  Fixed Price   
STARTDATE  Date  Start Date   

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.